xtc_db_prepare_input($customers['customers_id']), 'customers_cid' => xtc_db_prepare_input($customers1['customers_cid']), 'customers_vat_id' => xtc_db_prepare_input($customers1['customers_vat_id']), 'customers_status' => xtc_db_prepare_input($customers1['customers_status']), 'customers_status_name' => xtc_db_prepare_input($stat['customers_status_name']), 'customers_status_image' => xtc_db_prepare_input($stat['customers_status_image']), 'customers_status_discount' => xtc_db_prepare_input($stat['customers_status_discount']), 'customers_name' => xtc_db_prepare_input($customers['entry_firstname'].' '.$customers['entry_lastname']), 'customers_company' => xtc_db_prepare_input($customers['entry_company']), 'customers_street_address' => xtc_db_prepare_input($customers['entry_street_address']), 'customers_suburb' => xtc_db_prepare_input($customers['entry_suburb']), 'customers_city' => xtc_db_prepare_input($customers['entry_city']), 'customers_postcode' => xtc_db_prepare_input($customers['entry_postcode']), 'customers_state' => xtc_db_prepare_input($customers['entry_state']), 'customers_country' => xtc_db_prepare_input($country['countries_name']), 'customers_telephone' => xtc_db_prepare_input($customers1['customers_telephone']), 'customers_email_address' => xtc_db_prepare_input($customers1['customers_email_address']), 'customers_address_format_id' => '5', 'customers_ip' => '0', 'delivery_name' => xtc_db_prepare_input($customers['entry_firstname'].' '.$customers['entry_lastname']), 'delivery_company' => xtc_db_prepare_input($customers['entry_company']), 'delivery_street_address' => xtc_db_prepare_input($customers['entry_street_address']), 'delivery_suburb' => xtc_db_prepare_input($customers['entry_suburb']), 'delivery_city' => xtc_db_prepare_input($customers['entry_city']), 'delivery_postcode' => xtc_db_prepare_input($customers['entry_postcode']), 'delivery_state' => xtc_db_prepare_input($customers['entry_state']), 'delivery_country' => xtc_db_prepare_input($country['countries_name']), 'delivery_address_format_id' => '5', 'billing_name' => xtc_db_prepare_input($customers['entry_firstname'].' '.$customers['entry_lastname']), 'billing_company' => xtc_db_prepare_input($customers['entry_company']), 'billing_street_address' => xtc_db_prepare_input($customers['entry_street_address']), 'billing_suburb' => xtc_db_prepare_input($customers['entry_suburb']), 'billing_city' => xtc_db_prepare_input($customers['entry_city']), 'billing_postcode' => xtc_db_prepare_input($customers['entry_postcode']), 'billing_state' => xtc_db_prepare_input($customers['entry_state']), 'billing_country' => xtc_db_prepare_input($country['countries_name']), 'billing_address_format_id' => '5', 'payment_method' => 'cod', 'cc_type' => '', 'cc_owner' => '', 'cc_number' => '', 'cc_expires' => '', 'cc_start' => '', 'cc_issue' => '', 'cc_cvv' => '', 'comments' => '', 'last_modified' => 'now()', 'date_purchased' => 'now()', 'orders_status' => '1', 'orders_date_finished' => '', 'currency' => 'EUR', 'currency_value' => '1.0000', 'account_type' => '0', 'payment_class' => 'cod', 'shipping_method' => 'Pauschale Versandkosten', 'shipping_class' => 'flat_flat', 'customers_ip' => '', 'language' => 'german');
$insert_sql_data = array ('currency_value' => '1.0000');
$sql_data_array = xtc_array_merge($sql_data_array, $insert_sql_data);
xtc_db_perform(TABLE_ORDERS, $sql_data_array);
$orders_id = xtc_db_insert_id();
$sql_data_array = array ('orders_id' => $orders_id, 'title' => 'Summe :', 'text' => '0', 'value' => '0', 'class' => 'ot_total');
$insert_sql_data = array ('sort_order' => MODULE_ORDER_TOTAL_TOTAL_SORT_ORDER);
$sql_data_array = xtc_array_merge($sql_data_array, $insert_sql_data);
xtc_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);
$sql_data_array = array ('orders_id' => $orders_id, 'title' => 'Zwischensumme :', 'text' => '0', 'value' => '0', 'class' => 'ot_subtotal');
$insert_sql_data = array ('sort_order' => MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER);
$sql_data_array = xtc_array_merge($sql_data_array, $insert_sql_data);
xtc_db_perform(TABLE_ORDERS_TOTAL, $sql_data_array);
xtc_redirect(xtc_href_link(FILENAME_ORDERS, 'oID='.$orders_id.'&action=edit'));
break;
case 'statusconfirm' :
$customers_id = xtc_db_prepare_input($_GET['cID']);
$customer_updated = false;
$check_status_query = xtc_db_query("select customers_firstname, customers_lastname, customers_email_address , customers_status, member_flag from ".TABLE_CUSTOMERS." where customers_id = '".xtc_db_input($_GET['cID'])."'");
$check_status = xtc_db_fetch_array($check_status_query);
if ($check_status['customers_status'] != $status) {
xtc_db_query("update ".TABLE_CUSTOMERS." set customers_status = '".xtc_db_input($_POST['status'])."' where customers_id = '".xtc_db_input($_GET['cID'])."'");
// create insert for admin access table if customers status is set to 0
if ($_POST['status'] == 0) {
xtc_db_query("INSERT into ".TABLE_ADMIN_ACCESS." (customers_id,start) VALUES ('".xtc_db_input($_GET['cID'])."','1')");
} else {
xtc_db_query("DELETE FROM ".TABLE_ADMIN_ACCESS." WHERE customers_id = '".xtc_db_input($_GET['cID'])."'");
}
//Temporarily set due to above commented lines
$customer_notified = '0';
xtc_db_query("insert into ".TABLE_CUSTOMERS_STATUS_HISTORY." (customers_id, new_value, old_value, date_added, customer_notified) values ('".xtc_db_input($_GET['cID'])."', '".xtc_db_input($_POST['status'])."', '".$check_status['customers_status']."', now(), '".$customer_notified."')");
$customer_updated = true;
}
xtc_redirect(xtc_href_link(FILENAME_CUSTOMERS, 'page='.$_GET['page'].'&cID='.$_GET['cID']));
break;
case 'update' :
$customers_id = xtc_db_prepare_input($_GET['cID']);
$customers_cid = xtc_db_prepare_input($_POST['csID']);
$customers_vat_id = xtc_db_prepare_input($_POST['customers_vat_id']);
$customers_vat_id_status = xtc_db_prepare_input($_POST['customers_vat_id_status']);
$customers_firstname = xtc_db_prepare_input($_POST['customers_firstname']);
$customers_lastname = xtc_db_prepare_input($_POST['customers_lastname']);
$customers_email_address = xtc_db_prepare_input($_POST['customers_email_address']);
$customers_telephone = xtc_db_prepare_input($_POST['customers_telephone']);
$customers_fax = xtc_db_prepare_input($_POST['customers_fax']);
$customers_newsletter = xtc_db_prepare_input($_POST['customers_newsletter']);
$customers_gender = xtc_db_prepare_input($_POST['customers_gender']);
$customers_dob = xtc_db_prepare_input($_POST['customers_dob']);
$default_address_id = xtc_db_prepare_input($_POST['default_address_id']);
$entry_street_address = xtc_db_prepare_input($_POST['entry_street_address']);
$entry_suburb = xtc_db_prepare_input($_POST['entry_suburb']);
$entry_postcode = xtc_db_prepare_input($_POST['entry_postcode']);
$entry_city = xtc_db_prepare_input($_POST['entry_city']);
$entry_country_id = xtc_db_prepare_input($_POST['entry_country_id']);
$entry_company = xtc_db_prepare_input($_POST['entry_company']);
$entry_state = xtc_db_prepare_input($_POST['entry_state']);
$entry_zone_id = xtc_db_prepare_input($_POST['entry_zone_id']);
$memo_title = xtc_db_prepare_input($_POST['memo_title']);
$memo_text = xtc_db_prepare_input($_POST['memo_text']);
$payment_unallowed = xtc_db_prepare_input($_POST['payment_unallowed']);
$shipping_unallowed = xtc_db_prepare_input($_POST['shipping_unallowed']);
$password = xtc_db_prepare_input($_POST['entry_password']);
if ($memo_text != '' && $memo_title != '') {
$sql_data_array = array ('customers_id' => $_GET['cID'], 'memo_date' => date("Y-m-d"), 'memo_title' => $memo_title, 'memo_text' => $memo_text, 'poster_id' => $_SESSION['customer_id']);
xtc_db_perform(TABLE_CUSTOMERS_MEMO, $sql_data_array);
}
$error = false; // reset error flag
if (strlen($customers_firstname) < ENTRY_FIRST_NAME_MIN_LENGTH) {
$error = true;
$entry_firstname_error = true;
} else {
$entry_firstname_error = false;
}
if (strlen($customers_lastname) < ENTRY_LAST_NAME_MIN_LENGTH) {
$error = true;
$entry_lastname_error = true;
} else {
$entry_lastname_error = false;
}
if (ACCOUNT_DOB == 'true') {
if (checkdate(substr(xtc_date_raw($customers_dob), 4, 2), substr(xtc_date_raw($customers_dob), 6, 2), substr(xtc_date_raw($customers_dob), 0, 4))) {
$entry_date_of_birth_error = false;
} else {
$error = true;
$entry_date_of_birth_error = true;
}
}
// New VAT Check
if (xtc_get_geo_zone_code($entry_country_id) != '6') {
require_once(DIR_FS_CATALOG.DIR_WS_CLASSES.'vat_validation.php');
$vatID = new vat_validation($customers_vat_id, $customers_id, '', $entry_country_id);
$customers_vat_id_status = $vatID->vat_info['vat_id_status'];
$error = $vatID->vat_info['error'];
if($error==1){
$entry_vat_error = true;
$error = true;
}
}
// New VAT CHECK END
if (strlen($customers_email_address) < ENTRY_EMAIL_ADDRESS_MIN_LENGTH) {
$error = true;
$entry_email_address_error = true;
} else {
$entry_email_address_error = false;
}
if (!xtc_validate_email($customers_email_address)) {
$error = true;
$entry_email_address_check_error = true;
} else {
$entry_email_address_check_error = false;
}
if (strlen($entry_street_address) < ENTRY_STREET_ADDRESS_MIN_LENGTH) {
$error = true;
$entry_street_address_error = true;
} else {
$entry_street_address_error = false;
}
if (strlen($entry_postcode) < ENTRY_POSTCODE_MIN_LENGTH) {
$error = true;
$entry_post_code_error = true;
} else {
$entry_post_code_error = false;
}
if (strlen($entry_city) < ENTRY_CITY_MIN_LENGTH) {
$error = true;
$entry_city_error = true;
} else {
$entry_city_error = false;
}
if ($entry_country_id == false) {
$error = true;
$entry_country_error = true;
} else {
$entry_country_error = false;
}
if (ACCOUNT_STATE == 'true') {
if ($entry_country_error == true) {
$entry_state_error = true;
} else {
$zone_id = 0;
$entry_state_error = false;
$check_query = xtc_db_query("select count(*) as total from ".TABLE_ZONES." where zone_country_id = '".xtc_db_input($entry_country_id)."'");
$check_value = xtc_db_fetch_array($check_query);
$entry_state_has_zones = ($check_value['total'] > 0);
if ($entry_state_has_zones == true) {
$zone_query = xtc_db_query("select zone_id from ".TABLE_ZONES." where zone_country_id = '".xtc_db_input($entry_country_id)."' and zone_name = '".xtc_db_input($entry_state)."'");
if (xtc_db_num_rows($zone_query) == 1) {
$zone_values = xtc_db_fetch_array($zone_query);
$entry_zone_id = $zone_values['zone_id'];
} else {
$zone_query = xtc_db_query("select zone_id from ".TABLE_ZONES." where zone_country_id = '".xtc_db_input($entry_country)."' and zone_code = '".xtc_db_input($entry_state)."'");
if (xtc_db_num_rows($zone_query) >= 1) {
$zone_values = xtc_db_fetch_array($zone_query);
$zone_id = $zone_values['zone_id'];
} else {
$error = true;
$entry_state_error = true;
}
}
} else {
if ($entry_state == false) {
$error = true;
$entry_state_error = true;
}
}
}
}
if (strlen($customers_telephone) < ENTRY_TELEPHONE_MIN_LENGTH) {
$error = true;
$entry_telephone_error = true;
} else {
$entry_telephone_error = false;
}
/*
if (strlen($password) < ENTRY_PASSWORD_MIN_LENGTH) {
$error = true;
$entry_password_error = true;
} else {
$entry_password_error = false;
}
*/
$check_email = xtc_db_query("select customers_email_address from ".TABLE_CUSTOMERS." where customers_email_address = '".xtc_db_input($customers_email_address)."' and customers_id <> '".xtc_db_input($customers_id)."'");
if (xtc_db_num_rows($check_email)) {
$error = true;
$entry_email_address_exists = true;
} else {
$entry_email_address_exists = false;
}
if ($error == false) {
$sql_data_array = array ('customers_firstname' => $customers_firstname, 'customers_cid' => $customers_cid, 'customers_vat_id' => $customers_vat_id, 'customers_vat_id_status' => $customers_vat_id_status, 'customers_lastname' => $customers_lastname, 'customers_email_address' => $customers_email_address, 'customers_telephone' => $customers_telephone, 'customers_fax' => $customers_fax, 'payment_unallowed' => $payment_unallowed, 'shipping_unallowed' => $shipping_unallowed, 'customers_newsletter' => $customers_newsletter,'customers_last_modified' => 'now()');
// if new password is set
if ($password != "") {
$sql_data_array=array_merge($sql_data_array,array('customers_password' => xtc_encrypt_password($password)));
}
if (ACCOUNT_GENDER == 'true')
$sql_data_array['customers_gender'] = $customers_gender;
if (ACCOUNT_DOB == 'true')
$sql_data_array['customers_dob'] = xtc_date_raw($customers_dob);
xtc_db_perform(TABLE_CUSTOMERS, $sql_data_array, 'update', "customers_id = '".xtc_db_input($customers_id)."'");
xtc_db_query("update ".TABLE_CUSTOMERS_INFO." set customers_info_date_account_last_modified = now() where customers_info_id = '".xtc_db_input($customers_id)."'");
if ($entry_zone_id > 0)
$entry_state = '';
$sql_data_array = array ('entry_firstname' => $customers_firstname, 'entry_lastname' => $customers_lastname, 'entry_street_address' => $entry_street_address, 'entry_postcode' => $entry_postcode, 'entry_city' => $entry_city, 'entry_country_id' => $entry_country_id,'address_last_modified' => 'now()');
if (ACCOUNT_COMPANY == 'true')
$sql_data_array['entry_company'] = $entry_company;
if (ACCOUNT_SUBURB == 'true')
$sql_data_array['entry_suburb'] = $entry_suburb;
if (ACCOUNT_STATE == 'true') {
if ($entry_zone_id > 0) {
$sql_data_array['entry_zone_id'] = $entry_zone_id;
$sql_data_array['entry_state'] = '';
} else {
$sql_data_array['entry_zone_id'] = '0';
$sql_data_array['entry_state'] = $entry_state;
}
}
xtc_db_perform(TABLE_ADDRESS_BOOK, $sql_data_array, 'update', "customers_id = '".xtc_db_input($customers_id)."' and address_book_id = '".xtc_db_input($default_address_id)."'");
xtc_redirect(xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array ('cID', 'action')).'cID='.$customers_id));
}
elseif ($error == true) {
$cInfo = new objectInfo($_POST);
$processed = true;
}
break;
case 'deleteconfirm' :
$customers_id = xtc_db_prepare_input($_GET['cID']);
if ($_POST['delete_reviews'] == 'on') {
$reviews_query = xtc_db_query("select reviews_id from ".TABLE_REVIEWS." where customers_id = '".xtc_db_input($customers_id)."'");
while ($reviews = xtc_db_fetch_array($reviews_query)) {
xtc_db_query("delete from ".TABLE_REVIEWS_DESCRIPTION." where reviews_id = '".$reviews['reviews_id']."'");
}
xtc_db_query("delete from ".TABLE_REVIEWS." where customers_id = '".xtc_db_input($customers_id)."'");
} else {
xtc_db_query("update ".TABLE_REVIEWS." set customers_id = null where customers_id = '".xtc_db_input($customers_id)."'");
}
xtc_db_query("delete from ".TABLE_ADDRESS_BOOK." where customers_id = '".xtc_db_input($customers_id)."'");
xtc_db_query("delete from ".TABLE_CUSTOMERS." where customers_id = '".xtc_db_input($customers_id)."'");
xtc_db_query("delete from ".TABLE_CUSTOMERS_INFO." where customers_info_id = '".xtc_db_input($customers_id)."'");
xtc_db_query("delete from ".TABLE_CUSTOMERS_BASKET." where customers_id = '".xtc_db_input($customers_id)."'");
xtc_db_query("delete from ".TABLE_CUSTOMERS_BASKET_ATTRIBUTES." where customers_id = '".xtc_db_input($customers_id)."'");
xtc_db_query("delete from ".TABLE_PRODUCTS_NOTIFICATIONS." where customers_id = '".xtc_db_input($customers_id)."'");
xtc_db_query("delete from ".TABLE_WHOS_ONLINE." where customer_id = '".xtc_db_input($customers_id)."'");
xtc_db_query("delete from ".TABLE_CUSTOMERS_STATUS_HISTORY." where customers_id = '".xtc_db_input($customers_id)."'");
xtc_db_query("delete from ".TABLE_CUSTOMERS_IP." where customers_id = '".xtc_db_input($customers_id)."'");
xtc_db_query("DELETE FROM ".TABLE_ADMIN_ACCESS." WHERE customers_id = '".xtc_db_input($customers_id)."'");
xtc_redirect(xtc_href_link(FILENAME_CUSTOMERS, xtc_get_all_get_params(array ('cID', 'action'))));
break;
default :
$customers_query = xtc_db_query("select c.customers_id,c.customers_cid, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from ".TABLE_CUSTOMERS." c left join ".TABLE_ADDRESS_BOOK." a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '".$_GET['cID']."'");
$customers = xtc_db_fetch_array($customers_query);
$cInfo = new objectInfo($customers);
}
}
?>
>
'1', 'text' => ENTRY_NEWSLETTER_YES), array ('id' => '0', 'text' => ENTRY_NEWSLETTER_NO));
?>
customers_lastname.' '.$cInfo->customers_firstname; ?>
XT Customers
customers_default_address_id); ?>
customers_gender).' '.MALE.' '.xtc_draw_radio_field('customers_gender', 'f', false, $cInfo->customers_gender).' '.FEMALE.' '.ENTRY_GENDER_ERROR;
} else {
echo ($cInfo->customers_gender == 'm') ? MALE : FEMALE;
echo xtc_draw_hidden_field('customers_gender');
}
} else {
echo xtc_draw_radio_field('customers_gender', 'm', false, $cInfo->customers_gender).' '.MALE.' '.xtc_draw_radio_field('customers_gender', 'f', false, $cInfo->customers_gender).' '.FEMALE;
}
?>
customers_cid, 'maxlength="32"', false);
?>
customers_firstname, 'maxlength="32"').' '.ENTRY_FIRST_NAME_ERROR;
} else {
echo xtc_draw_input_field('customers_firstname', $cInfo->customers_firstname, 'maxlength="32"', true);
}
?>
customers_lastname, 'maxlength="32"').' '.ENTRY_LAST_NAME_ERROR;
} else {
echo $cInfo->customers_lastname.xtc_draw_hidden_field('customers_lastname');
}
} else {
echo xtc_draw_input_field('customers_lastname', $cInfo->customers_lastname, 'maxlength="32"', true);
}
?>
customers_dob), 'maxlength="10"').' '.ENTRY_DATE_OF_BIRTH_ERROR;
} else {
echo $cInfo->customers_dob.xtc_draw_hidden_field('customers_dob');
}
} else {
echo xtc_draw_input_field('customers_dob', xtc_date_short($cInfo->customers_dob), 'maxlength="10"', true);
}
?>
customers_email_address, 'maxlength="96"').' '.ENTRY_EMAIL_ADDRESS_ERROR;
}
elseif ($entry_email_address_check_error == true) {
echo xtc_draw_input_field('customers_email_address', $cInfo->customers_email_address, 'maxlength="96"').' '.ENTRY_EMAIL_ADDRESS_CHECK_ERROR;
}
elseif ($entry_email_address_exists == true) {
echo xtc_draw_input_field('customers_email_address', $cInfo->customers_email_address, 'maxlength="96"').' '.ENTRY_EMAIL_ADDRESS_ERROR_EXISTS;
} else {
echo $customers_email_address.xtc_draw_hidden_field('customers_email_address');
}
} else {
echo xtc_draw_input_field('customers_email_address', $cInfo->customers_email_address, 'maxlength="96"', true);
}
?>
entry_company, 'maxlength="32"').' '.ENTRY_COMPANY_ERROR;
} else {
echo $cInfo->entry_company.xtc_draw_hidden_field('entry_company');
}
} else {
echo xtc_draw_input_field('entry_company', $cInfo->entry_company, 'maxlength="32"');
}
?>
customers_vat_id, 'maxlength="32"').' '.ENTRY_VAT_ID_ERROR;
} else {
echo $cInfo->customers_vat_id.xtc_draw_hidden_field('customers_vat_id');
}
} else {
echo xtc_draw_input_field('customers_vat_id', $cInfo->customers_vat_id, 'maxlength="32"');
}
?>
entry_street_address, 'maxlength="64"').' '.ENTRY_STREET_ADDRESS_ERROR;
} else {
echo $cInfo->entry_street_address.xtc_draw_hidden_field('entry_street_address');
}
} else {
echo xtc_draw_input_field('entry_street_address', $cInfo->entry_street_address, 'maxlength="64"', true);
}
?>
entry_suburb, 'maxlength="32"').' '.ENTRY_SUBURB_ERROR;
} else {
echo $cInfo->entry_suburb.xtc_draw_hidden_field('entry_suburb');
}
} else {
echo xtc_draw_input_field('entry_suburb', $cInfo->entry_suburb, 'maxlength="32"');
}
?>
entry_postcode, 'maxlength="8"').' '.ENTRY_POST_CODE_ERROR;
} else {
echo $cInfo->entry_postcode.xtc_draw_hidden_field('entry_postcode');
}
} else {
echo xtc_draw_input_field('entry_postcode', $cInfo->entry_postcode, 'maxlength="8"', true);
}
?>
entry_city, 'maxlength="32"').' '.ENTRY_CITY_ERROR;
} else {
echo $cInfo->entry_city.xtc_draw_hidden_field('entry_city');
}
} else {
echo xtc_draw_input_field('entry_city', $cInfo->entry_city, 'maxlength="32"', true);
}
?>
entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state);
if ($error == true) {
if ($entry_state_error == true) {
if ($entry_state_has_zones == true) {
$zones_array = array ();
$zones_query = xtc_db_query("select zone_name from ".TABLE_ZONES." where zone_country_id = '".xtc_db_input($cInfo->entry_country_id)."' order by zone_name");
while ($zones_values = xtc_db_fetch_array($zones_query)) {
$zones_array[] = array ('id' => $zones_values['zone_name'], 'text' => $zones_values['zone_name']);
}
echo xtc_draw_pull_down_menu('entry_state', $zones_array).' '.ENTRY_STATE_ERROR;
} else {
echo xtc_draw_input_field('entry_state', xtc_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state)).' '.ENTRY_STATE_ERROR;
}
} else {
echo $entry_state.xtc_draw_hidden_field('entry_zone_id').xtc_draw_hidden_field('entry_state');
}
} else {
echo xtc_draw_input_field('entry_state', xtc_get_zone_name($cInfo->entry_country_id, $cInfo->entry_zone_id, $cInfo->entry_state));
}
?>
entry_country_id).' '.ENTRY_COUNTRY_ERROR;
} else {
echo xtc_get_country_name($cInfo->entry_country_id).xtc_draw_hidden_field('entry_country_id');
}
} else {
echo xtc_draw_pull_down_menu('entry_country_id', xtc_get_countries(), $cInfo->entry_country_id);
}
?>
customers_telephone, 'maxlength="32"').' '.ENTRY_TELEPHONE_NUMBER_ERROR;
} else {
echo $cInfo->customers_telephone.xtc_draw_hidden_field('customers_telephone');
}
} else {
echo xtc_draw_input_field('customers_telephone', $cInfo->customers_telephone, 'maxlength="32"', true);
}
?>
customers_fax.xtc_draw_hidden_field('customers_fax');
} else {
echo xtc_draw_input_field('customers_fax', $cInfo->customers_fax, 'maxlength="32"');
}
?>
payment_unallowed.xtc_draw_hidden_field('payment_unallowed');
} else {
echo xtc_draw_input_field('payment_unallowed', $cInfo->payment_unallowed, 'maxlength="255"');
}
?>
shipping_unallowed.xtc_draw_hidden_field('shipping_unallowed');
} else {
echo xtc_draw_input_field('shipping_unallowed', $cInfo->shipping_unallowed, 'maxlength="255"');
}
?>
customers_newsletter == '1') {
echo ENTRY_NEWSLETTER_YES;
} else {
echo ENTRY_NEWSLETTER_NO;
}
echo xtc_draw_hidden_field('customers_newsletter');
} else {
echo xtc_draw_pull_down_menu('customers_newsletter', $newsletter_array, $cInfo->customers_newsletter);
}
?>
' . BUTTON_CANCEL . ''; ?>
' . BUTTON_CREATE_ACCOUNT . ''; ?>
'99', 'text' => TEXT_SELECT), array ('id' => '100', 'text' => TEXT_ALL_CUSTOMERS));
?>
// das soll hier hin 1/2
// das soll hier hin 2/2
customers_id)) {
echo ' '."\n";
} else {
echo ' '."\n";
}
if ($customers['account_type'] == 1) {
echo '';
echo TEXT_GUEST;
} else {
echo ' ';
echo TEXT_ACCOUNT;
}
?>
('.xtc_validate_vatid_status($customers['customers_id']).') ';
}
?>
customers_id) ) { echo xtc_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '' . xtc_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . ' '; } ?>
display_count($customers_query_numrows, '20', $_GET['page'], TEXT_DISPLAY_NUMBER_OF_CUSTOMERS); ?>
display_links($customers_query_numrows, '20', MAX_DISPLAY_PAGE_LINKS, $_GET['page'], xtc_get_all_get_params(array('page', 'info', 'x', 'y', 'cID'))); ?>
' . BUTTON_RESET . ''; ?>
''.TEXT_INFO_HEADING_DELETE_CUSTOMER.' ');
$contents = array ('form' => xtc_draw_form('customers', FILENAME_CUSTOMERS, xtc_get_all_get_params(array ('cID', 'action')).'cID='.$cInfo->customers_id.'&action=deleteconfirm'));
$contents[] = array ('text' => TEXT_DELETE_INTRO.''.$cInfo->customers_firstname.' '.$cInfo->customers_lastname.' ');
if ($cInfo->number_of_reviews > 0)
$contents[] = array ('text' => ' '.xtc_draw_checkbox_field('delete_reviews', 'on', true).' '.sprintf(TEXT_DELETE_REVIEWS, $cInfo->number_of_reviews));
$contents[] = array ('align' => 'center', 'text' => ''.BUTTON_CANCEL.' ');
break;
case 'editstatus' :
if ($_GET['cID'] != 1) {
$customers_history_query = xtc_db_query("select new_value, old_value, date_added, customer_notified from ".TABLE_CUSTOMERS_STATUS_HISTORY." where customers_id = '".xtc_db_input($_GET['cID'])."' order by customers_status_history_id desc");
$heading[] = array ('text' => ''.TEXT_INFO_HEADING_STATUS_CUSTOMER.' ');
$contents = array ('form' => xtc_draw_form('customers', FILENAME_CUSTOMERS, xtc_get_all_get_params(array ('cID', 'action')).'cID='.$cInfo->customers_id.'&action=statusconfirm'));
$contents[] = array ('text' => ' '.xtc_draw_pull_down_menu('status', $customers_statuses_array, $cInfo->customers_status));
$contents[] = array ('text' => ''.TABLE_HEADING_NEW_VALUE.' '.TABLE_HEADING_DATE_ADDED.' ');
if (xtc_db_num_rows($customers_history_query)) {
while ($customers_history = xtc_db_fetch_array($customers_history_query)) {
$contents[] = array ('text' => ''."\n".''.$customers_statuses_array[$customers_history['new_value']]['text'].' '."\n".''.xtc_datetime_short($customers_history['date_added']).' '."\n".'');
$contents[] = array ('text' => ' '."\n");
}
} else {
$contents[] = array ('text' => ''."\n".' '.TEXT_NO_CUSTOMER_HISTORY.' '."\n".' '."\n");
}
$contents[] = array ('text' => '
');
$contents[] = array ('align' => 'center', 'text' => ''.BUTTON_CANCEL.' ');
$status = xtc_db_prepare_input($_POST['status']); // maybe this line not needed to recheck...
}
break;
default :
$customer_status = xtc_get_customer_status($_GET['cID']);
$cs_id = $customer_status['customers_status'];
$cs_member_flag = $customer_status['member_flag'];
$cs_name = $customer_status['customers_status_name'];
$cs_image = $customer_status['customers_status_image'];
$cs_discount = $customer_status['customers_status_discount'];
$cs_ot_discount_flag = $customer_status['customers_status_ot_discount_flag'];
$cs_ot_discount = $customer_status['customers_status_ot_discount'];
$cs_staffelpreise = $customer_status['customers_status_staffelpreise'];
$cs_payment_unallowed = $customer_status['customers_status_payment_unallowed'];
// echo 'customer_status ' . $cID . 'variables = ' . $cs_id . $cs_member_flag . $cs_name . $cs_discount . $cs_image . $cs_ot_discount;
if (is_object($cInfo)) {
$heading[] = array ('text' => ''.$cInfo->customers_firstname.' '.$cInfo->customers_lastname.' ');
if ($cInfo->customers_id != 1) {
$contents[] = array ('align' => 'center', 'text' => ''.BUTTON_EDIT.' ');
}
if ($cInfo->customers_id == 1 && $_SESSION['customer_id'] == 1) {
$contents[] = array ('align' => 'center', 'text' => ''.BUTTON_EDIT.' ');
}
if ($cInfo->customers_id != 1) {
$contents[] = array ('align' => 'center', 'text' => ''.BUTTON_DELETE.' ');
}
if ($cInfo->customers_id != 1 /*&& $_SESSION['customer_id'] == 1*/
) {
$contents[] = array ('align' => 'center', 'text' => ''.BUTTON_STATUS.' ');
}
// elari cs v3.x changed for added accounting module
if ($cInfo->customers_id != 1) {
$contents[] = array ('align' => 'center', 'text' => ''.BUTTON_ACCOUNTING.' ');
}
// elari cs v3.x changed for added iplog module
$contents[] = array ('align' => 'center', 'text' => '');
$contents[] = array ('text' => ' '.TEXT_DATE_ACCOUNT_CREATED.' '.xtc_date_short($cInfo->date_account_created));
$contents[] = array ('text' => ' '.TEXT_DATE_ACCOUNT_LAST_MODIFIED.' '.xtc_date_short($cInfo->date_account_last_modified));
$contents[] = array ('text' => ' '.TEXT_INFO_DATE_LAST_LOGON.' '.xtc_date_short($cInfo->date_last_logon));
$contents[] = array ('text' => ' '.TEXT_INFO_NUMBER_OF_LOGONS.' '.$cInfo->number_of_logons);
$contents[] = array ('text' => ' '.TEXT_INFO_COUNTRY.' '.$cInfo->countries_name);
$contents[] = array ('text' => ' '.TEXT_INFO_NUMBER_OF_REVIEWS.' '.$cInfo->number_of_reviews);
}
if ($_GET['action'] == 'iplog') {
if (isset ($_GET['cID'])) {
$contents[] = array ('text' => 'IPLOG :');
$customers_id = xtc_db_prepare_input($_GET['cID']);
$customers_log_info_array = xtc_get_user_info($customers_id);
if (xtc_db_num_rows($customers_log_info_array)) {
while ($customers_log_info = xtc_db_fetch_array($customers_log_info_array)) {
$contents[] = array ('text' => ''."\n".''.$customers_log_info['customers_ip_date'].' '.$customers_log_info['customers_ip'].' '.$customers_log_info['customers_advertiser']);
}
}
}
break;
}
}
// das soll nach oben ANFANG
if ((xtc_not_null($heading)) && (xtc_not_null($contents))) {
echo ' '."\n";
$box = new box;
echo $box->infoBox($heading, $contents);
echo ' '."\n";
}
// das soll nach oben ENDE
?>